use KBManagement
go
INSERT INTO dbo.Category (ID, "Name", Status) 
	VALUES ('BIA', 'Bi-A', 1)
INSERT INTO dbo.Category (ID, "Name", Status) 
	VALUES ('KAR', 'Karaoke', 1)
--product
	
INSERT INTO dbo.Product ("Name", Price,ImageUsePath, ImageNotUsePath,CategoryID, Status) 
	VALUES ('PHONG_VIP', 25000, 'KAR','KAR1', 'KAR', 1)
INSERT INTO dbo.Product ("Name", Price,ImageUsePath, ImageNotUsePath,CategoryID, Status) 
	VALUES ('PHONG_01', 150000, 'KAR','KAR1', 'KAR', 1)
INSERT INTO dbo.Product ("Name", Price,ImageUsePath, ImageNotUsePath,CategoryID, Status) 
	VALUES ('PHONG_02', 150000, 'KAR','KAR1', 'KAR', 1)
INSERT INTO dbo.Product ("Name", Price,ImageUsePath, ImageNotUsePath,CategoryID, Status) 
	VALUES ('PHONG_03', 150000, 'KAR','KAR1', 'KAR', 1)
INSERT INTO dbo.Product ("Name", Price,ImageUsePath, ImageNotUsePath,CategoryID, Status) 
	VALUES ('PHONG_04', 150000, 'KAR','KAR1', 'KAR', 1)
INSERT INTO dbo.Product ("Name", Price,ImageUsePath, ImageNotUsePath,CategoryID, Status) 
	VALUES ('PHONG_05', 150000, 'KAR','KAR1', 'KAR', 1)


INSERT INTO dbo.Product ("Name", Price,ImageUsePath, ImageNotUsePath,CategoryID, Status) 
	VALUES ('BAN_01', 25000, 'images','images1', 'BIA', 1)
INSERT INTO dbo.Product ("Name", Price,ImageUsePath, ImageNotUsePath,CategoryID, Status) 
	VALUES ('BAN_02', 150000, 'images','images1', 'BIA', 1)
INSERT INTO dbo.Product ("Name", Price,ImageUsePath, ImageNotUsePath,CategoryID, Status) 
	VALUES ('BAN_03', 150000, 'images','images1', 'BIA', 1)
INSERT INTO dbo.Product ("Name", Price,ImageUsePath, ImageNotUsePath,CategoryID, Status) 
	VALUES ('BAN_04', 150000, 'images','images1', 'BIA', 1)
INSERT INTO dbo.Product ("Name", Price,ImageUsePath, ImageNotUsePath,CategoryID, Status) 
	VALUES ('BAN_05', 150000, 'images','images1', 'BIA', 1)
INSERT INTO dbo.Product ("Name", Price,ImageUsePath, ImageNotUsePath,CategoryID, Status) 
	VALUES ('BAN_06', 150000, 'images','images1', 'BIA', 1)

GO

INSERT INTO dbo.Customer_Type (ID, "Ct_Name", Rate,NormsMoney, Status) 
	VALUES ('VIP', 'Khách hàng VIP', 20,20000000, 1)


INSERT INTO dbo.Customer_Type (ID, "Ct_Name", Rate,NormsMoney, Status) 
	VALUES ('KTX', 'Khách thường xuyên', 10,10000000, 1)

INSERT INTO dbo.Customer_Type (ID, "Ct_Name", Rate,NormsMoney, Status) 
	VALUES ('KL', 'Khách lạ', 0,0, 1)

--
GO

INSERT INTO dbo.Customer (FullName, Email, Adddress, Phone, CustomeTypeID, Status) 
	VALUES ('Khách Lạ', '', '', '0', 'KL', 1)

INSERT INTO dbo.Customer (FullName, Email, Adddress, Phone, CustomeTypeID, Status) 
	VALUES ('Duong van thanh', 'Thanhdvv@gmail.com', 'hoang mai hanoi', '0972852421', 'VIP', 1)

INSERT INTO dbo.Customer (FullName, Email, Adddress, Phone, CustomeTypeID, Status) 
	VALUES ('Hoang le ba', 'MrHoangba@gmail.com', 'hoang mai hanoi', '0909140207', 'KTX', 1)

GO
INSERT INTO [Role] VALUES ('admin','1')
GO

INSERT INTO [Admin] VALUES ('admin','admin','1','1')
GO

